package com.compus_help.Mapper;

import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface adminDashboardMapper {


    Integer getStudentsTotal();

    Integer getOrdersTotal();

    @MapKey("category_name")
    List<Map<String, Integer>> getCategoryOrdersTotal();

    @MapKey("college")
    List<Map<String, Object>> getStudentDistributionByCollege();

    @MapKey("college")
    List<Map<String, String>> getCollegeList();

    @MapKey("campus_card_number")
    List<Map<String, Object>> getStudentsByColleges(List<String> colleges);
}
